Overview
What is Azure SQL Database?
Azure SQL Database is Microsoft's relational database as a service (DBaaS).
My Azure SQL Database Review
Microsoft Azure SQL Database - Good Value - Great Features!
Simple, Fast, and Powerful
Cloud-based relational database service that is both intelligent and scalable.
Too expensive to be really useful overall.
Going to the cloud with Microsoft SQL, Azure SQL Database is surely the way to go!
Microsoft Azure SQL Database: Fully Managed and secure SQL database
AZURE cost effective reliability!
Secure Product Providing High-Performance
Azure SQL - your solution for Agility and Scalability
Azure SQL Database - Good Now, Getting Even Better
Easy decision, good price.
Azure SQL database makes ease the transition to Cloud
Azure SQL Databases is quick to scale
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Database scalability (27)10.0100%
- Automated backups (27)9.999%
- Database security provisions (27)9.090%
- Monitoring and metrics (26)9.090%
Pricing
2 vCORE
$0.5044
6 vCORE
$1.5131
10 vCORE
$2.52
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
How to connect to Azure SQL Database from Azure Data Studio | Data Exposed
What is Azure SQL Database Hyperscale?
Features
Database-as-a-Service
Database as a Service (DBaaS) software, sometimes referred to as cloud database software, is the delivery of database services ocer the Internet as a service
- 8.1Automatic software patching(25) Ratings
Patches applied to database automatically
- 10Database scalability(27) Ratings
Ease of scaling compute or memory resources and storage up or down
- 9.9Automated backups(27) Ratings
Automated backup enabling point-in-time data recovery
- 9Database security provisions(27) Ratings
Provision for database encryption, network isolation, and identity access management
- 9Monitoring and metrics(26) Ratings
Built-in monitoring of multiple operational metrics
- 9Automatic host deployment(22) Ratings
Compute instance replacement in the event of hardware failure
Product Details
- About
- Integrations
- Tech Details
- FAQs
What is Azure SQL Database?
Azure SQL Database Integrations
Azure SQL Database Technical Details
Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(272)Attribute Ratings
Reviews
(1-18 of 18)Best In Class Database
- Available all the time.
- Robust database.
- All apps easily connect with it.
- Easy to create data models.
- Easy management.
- Table creation and addition of new columns.
- Add more datatypes.
My Azure SQL Database Review
- Handling the software updates so we don't have to.
- Handling the availability so we don't have to.
- There are limits to the size of the database that I'd like to see go away.
- We don't have access to the server level counters that I miss but understand why we cannot get them.
- Azure SQL Database does a really nice job connection to the Power BI business intelligence service without the need for a data gateway for report refreshes.
- Azure SQL Database has a very easy upgrade path from a database to a data warehouse.
- Azure SQL Database has a simple billing structure.
- The Azure platform can be a little confusing sometimes with all the different options. Such is the Microsoft way.
- If you forget to put rate limits on your jobs, it's possible that your cost could explode.
- Learning the new Azure data tools to replace SSIS takes a while.
Simple, Fast, and Powerful
- Scalability
- Simplicity, ability to just focus on SQL, no need to manage anything else.
- High speed and minimal down time.
- Keeping data in the country you want.
- In the traditional on-premise Microsoft SQL Database structure, while everything the database developer does is almost the same in Azure, the database administrator needs to be separated from the interfaces they are used to.
- Job and Task manager work in different logic.
- The maintenance structure is different, if only it could stay the way we are used to.
- An excellent option for cloud-based database hosting
- Great if you already have on-premises SQL Databases that you want to migrate to the cloud
- Cost-effective solution for cloud DB hosting with great scaling capabilities
- Although it's a great option for migrating on-premises SQL DBs, it lacks some of the features of the on-premises SQL Server Instances
- Server Collation is limited to SQL_Latin1_General_CP1_CI_AS
- Logs support only [the] Full Recovery Model, which doesn't scale well for databases that contain logs/audit trail, or databases that contain engine jobs such as HangFire DBs
- Doesn't Support CLR, so certain on-premises databases with CLR are not compatible, so you are most likely left with the AzureSQL Managed Instance for this functionality
Overall, if you are building your solution from scratch, and prefer to use [...] familiar technology, Azure SQL is a great option, that is secure, flexible[,] and scalable, however, if you are migrating from on-premises, the decision to use Azure SQL Database depends on how compatible your current database is with it and whether its features are sufficient for your requirements or not.
It is a recommended solution though, and a very [cost-effective] one indeed!
- It is fully managed and secure SQL database.
- It is highly available and scalable.
- It provides automatic backup and restore.
- Documentation of Azure SQL is perfect with all best practices.
- I would love to see some new sizes of databases for compute and storage.
- prices related to different size can be improved.
- performance can be improved to reduce the latency.
There might be some performance issues when using it as an external database with kubernetes cluster. There might be some latency while performing database operations from a containerized app.
Secure Product Providing High-Performance
- Easy implementation thanks to the team working on the product launch.
- Set up features available are flawless.
- Very well suited to our needs. We are a company with more than 3k+ white collar employees.
- Data management and transfer is so secure, we feel there is no possibility for information theft from external sources.
- There might be room for improvement in visual interface. Some of my colleagues complain about basic operations could be carried out more easily, like administering other users.
- Set-up speed could be faster - currently it took around 10 min.
Azure SQL - your solution for Agility and Scalability
- It's extremely agile in that you can add/reduce resources as necessary for your organizations needs with minimal down time or cost.
- Zero need for on site software or servers to manage.
- ETL processing is vastly improved running through the cloud.
- Could perform better in accessing large data volumes.
- Due to varying price structures, evaluation for your specific needs can be cumbersome.
- Better system for notification/logging of DB errors.
Azure SQL Database - Good Now, Getting Even Better
- Scalability is #1: if it used to be an almost no-win endeavour to try to modernize your server or migrate to other hardware, with Azure SQL Database it becomes a press of a button.
- All the tools simply work after you are on Azure SQL Database.
- The applications do not need changes in order to start using Azure SQL Database.
- Hybrid Cloud scenarios will work.
- Clustering and failover - already there.
- You can start monitoring the use and extract performance insights in a new way in Azure.
- One needs to be aware that some T-SQL features are simply not available.
- The programmatic access to server, trace flags, hardware from within Azure SQL Database is taken away (for a good reason).
- No SQL Agent so your jobs need to be orchestrated differently.
- The maximum concurrent logins maybe an unexpected problem.
- Sudden disconnects.
- The developers and admin must study the capacity and tier usage limits https://docs.microsoft.com/en-us/azure/azure-subscription-service-limits otherwise some errors or even transaction aborts never seen before can occur.
- Only one Latin Collation choice.
- There is no way to debug T-SQL ( a big drawback in my point of view).
Azure SQL Databases is quick to scale
- Extremely Flexible- You have the ability to increase and decrease the performance resources as needed without taking a downtime or other burden.
- Connectivity- Connection to your SQL Database is easily accomplished with SSMS or PowerShell.
- Speed- Azure SQL Databases are quickly set up. You can have access and begin using your database within minutes.
- It would be appreciated for better integration between SSMS and Azure Database service. Example, you need to a provision user account with the Azure portal. It would be great to be able to do this within SSMS.
- Being able to run a back from SSMS versus from within the Azure Portal would be great. (Ability to create a standard .bak database backup).
Azure Sql rocks
- Agility of the platform
- No infrastructure maintenance and worry about upgrading, it's managed.
- Always on and universal availabilities
- No worry about backup recovery
- PowerBI connectors need improvement across 365 platform
- Data bricks can be inherent feature
- More robust integration to flow
Azure SQL Database: The Best PaaS offering for SQL Server
- Providing a SQL Server instance at low entry-level cost and global high-availability
- Elastic offerings so SaaS applications can cheaply have one-database-per-customer approach for high data segregation
- Intelligence performance recommendations from both Azure and the SQL Server engine itself
- Intelligent recommendations are not a silver bullet, since they often fail to detect opportunities that are obvious to a human database admin with any experience.
- Certain advanced database features - most recently I found: column store indices - are locked behind pricing tiers that one would naively assume are just about performance.
Intro to Azure SQL DB
- High availability
- Security features
- Ease of upgrade from on premise SQL
- Lacks full feature parity with SQL server
- More limited access to metrics for performance troubleshooting
- Hard to understand metrics used for sizing
Azure SQL DB is an example of how a DBaaS should be done.
- It optimizes cost - pay per usage. It can scale up and down as needed.
- It can be migrated to from Oracle, MySQL and other on premises databases.
- It is always updated with management and administrative functionalities being added weekly.
- Migration from on premises databases can be painful at first - but after couple of migrations it becomes easy.
- Network capabilities and restrictions should be carefully evaluated.
- It can be costly if you don't implement scale up/down automations.
The Hidden Savings of Using Azure
- The fact that it is available for the Azure cloud platform.
- The fact that it is easy to license as a monthly subscription and software access is simple.
- The fact that it functions exactly as its local server based counter part.
- It appears to have a slight delay in revealing data in the client software, then data will appear almost instantly. It is an odd feel when using it until you get used to it.
- It seems a bit slower than its local server based counter part.
- The tool bars icons are a little different and took some getting used to.
Reviewing Azure SQL Database
- Marketing automation and tracking
- SharePoint servers
- General Business Intelligence
- For what I use it for I haven't come across much
- User interface could be improved
- Navigation could be simplified
Azure "The Best to catch a breath for your self"
- The great thing about is even you are a pro or a newbie with Azure, you will not be tired of setting up SQL Server, the befitting pipelining of AZURE to cloud service where you don't need it onsite.
- You always don't need to update services, patches and deployment of supporting services. Cloud does make it someone else's job to do this.
- Generally obviates the need for building high availability architectures; Azure databases built within it are automatically highly available.
- Highly scalable and has vast support for non Microsoft technologies.
- One of the ways SQL Azure manifests being part of the whole stack is by offering multiple levels of implementation. If you simply need a website and a database, you can hitch an SQL Azure instance to an Azure website and be done with it.
- No schedulers available in case you require cron jobs.
- Certain username are not allowed (root, admin, administrator).
Azure SQL - Making Life Easier
- Point In Time Backup
- High Availability
- Scaling
- Provide customers more examples with Azure Automation (ways of doing backups, etc.) and then emailing when there is a failure.
- Decrease costs on premium.
- Allow customers to define a longer point in time backup recovery period.